USE [ANTS_NetServer]
GO

/****** Object:  StoredProcedure [dbo].[proc_NVRDeviceInfo_update]    Script Date: 04/21/2013 15:26:57 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create proc [dbo].[proc_NVRDeviceInfo_update]
(
	@deviceSN nvarchar(50),
	@deviceAdmin nvarchar(50),
	@devicePwd nvarchar(20),
	@deviceLoc nvarchar(50),
    @username nvarchar(50),
	@addDate datetime
)
as 
update NVRDeviceInfo
SET
	deviceAdmin = @deviceAdmin,
	devicePwd = @devicePwd,
	deviceLoc = @deviceLoc,
	username = @username,
	addDate = @addDate
where deviceSN=@deviceSN

GO

